package com.bgIntlgn.client.entity.manufacture;

import yuhuibear.poat.annotations.relation.View;
import yuhuibear.poat.object.bean.Bean;

/**
 * 统计在生产中零件的数量， 按uid 统计.
 * 
 * @author yuhui
 * 
 */
@View(name = "producing_stocks", sqlToCreate = "select pi.uid as uid, "
		+ "sum(pi.produced_quantity) as produced_quantity, " + "sum(pi.plan_quantity) as plan_quantity, "
		+ "sum(pi.total_quantity) as total_quantity " + "from production_plans as pp, production_iterms as pi "
		+ "where pp.state = 1 and pi.plan_id = pp.id group by pi.uid")
public class ProducingStock implements Bean {

	private String uid;
	/**
	 * 已生产数量
	 */
	private Long producedQuantity;

	/**
	 * 计划生产数量
	 */
	private Long planQuantity;

	/**
	 * 订单所需总数量
	 */
	private Long totalQuantity;

	public String getUid() {
		return this.uid;
	}

	public void setUid(String uid) {
		this.uid = uid;
	}

	public Long getProducedQuantity() {
		return this.producedQuantity;
	}

	public void setProducedQuantity(Long producedQuantity) {
		this.producedQuantity = producedQuantity;
	}

	public Long getPlanQuantity() {
		return this.planQuantity;
	}

	public void setPlanQuantity(Long planQuantity) {
		this.planQuantity = planQuantity;
	}

	public Long getTotalQuantity() {
		return this.totalQuantity;
	}

	public void setTotalQuantity(Long totalQuantity) {
		this.totalQuantity = totalQuantity;
	}
}
